<h1 class="top">Tables and columns(list)</h1>
<h2>The block</h2>
<img src="help/img/tabcol_list.png" alt="tables and columns block" class="leftFloatIMG" >
<p class="leftFloat left">
    This block symbolises the tables and columns of your database.  
    The '*' in the columnpart of the Block has the same meaning as 'all'. It symbolizes a complete list of the columns in this table.
    The block is used as a list in the "SELECT"-, "GROUP BY"- and "ORDER BY"-section: It is also used with the
    <span class="groupLinks pointer" onclick="fetchthelink('Help/groupfunction/avg.html', '#63a65a');">groupfunction</span>, the
    <span  class="groupLinks pointer" onclick="fetchthelink('Help/otherfunction/decode.html', '#5aa68c');"> otherfunction</span> and 
    <span class="groupLinks pointer" onclick="fetchthelink('Help/distinct.html', '#63a65a');">"DISTINCT"</span>.
</p>
<h2> Functionality</h2>
<p class="text">The default values in this block are, your first table in the database in the table-part and the '*' in the column-part.
    In this block are two dropdowns. In the left dropdown you can choose the table as you see in the picture below.
    In the right you can choose the column.
    <img src="help/img/tabcol_list_function.png" alt="tables and columns block" class="img" style="width: 300px; height: 236px;">  

<h2>The types</h2>
<img src="help/img/tabcol_list.png" alt="Type list" class="img" style="margin-top: 10px;">
<p class="text"> This colour ,apple green, symbolises a list of columns of the database</p>
<img src="help/img/tabcol_list_int.png" alt="Type numeric" class="img" >
<p class="text"> This colour,violet,  symbolises the numeric values of the database</p>
<img src="help/img/tabcol_list_text.png" alt="Type text" class="img">
<p class="text"> This colour, brown, symbolises the textual values of the database</p>
<img src="help/img/tabcol_list_date.png" alt="Type date" class="img">
<p class="text"> This colour,tapestry, symbolises the date values of the database</p>
<img src="help/img/tabcol_list_bool.png" alt="Type bool" class="img">
<p class="text"> This colour ,cyan, symbolises the boolean values of the database</p>
<div id="aliasback"></div>